<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
		<head>
			<!-- template designed by Marco Von Ballmoos  -->
			<title>Docs For Class DomSqlQuery</title>
			<link rel="stylesheet" href="../media/stylesheet.css" />
						<script src="../media/lib/classTree.js"></script>
												<script language="javascript" type="text/javascript">
				var imgPlus = new Image();
				var imgMinus = new Image();
				imgPlus.src = "../media/images/plus.png";
				imgMinus.src = "../media/images/minus.png";
				
				function showNode(Node){
							switch(navigator.family){
								case 'nn4':
									// Nav 4.x code fork...
							var oTable = document.layers["span" + Node];
							var oImg = document.layers["img" + Node];
									break;
								case 'ie4':
									// IE 4/5 code fork...
							var oTable = document.all["span" + Node];
							var oImg = document.all["img" + Node];
									break;
								case 'gecko':
									// Standards Compliant code fork...
							var oTable = document.getElementById("span" + Node);
							var oImg = document.getElementById("img" + Node);
									break;
							}
					oImg.src = imgMinus.src;
					oTable.style.display = "block";
				}
				
				function hideNode(Node){
							switch(navigator.family){
								case 'nn4':
									// Nav 4.x code fork...
							var oTable = document.layers["span" + Node];
							var oImg = document.layers["img" + Node];
									break;
								case 'ie4':
									// IE 4/5 code fork...
							var oTable = document.all["span" + Node];
							var oImg = document.all["img" + Node];
									break;
								case 'gecko':
									// Standards Compliant code fork...
							var oTable = document.getElementById("span" + Node);
							var oImg = document.getElementById("img" + Node);
									break;
							}
					oImg.src = imgPlus.src;
					oTable.style.display = "none";
				}
				
				function nodeIsVisible(Node){
							switch(navigator.family){
								case 'nn4':
									// Nav 4.x code fork...
							var oTable = document.layers["span" + Node];
									break;
								case 'ie4':
									// IE 4/5 code fork...
							var oTable = document.all["span" + Node];
									break;
								case 'gecko':
									// Standards Compliant code fork...
							var oTable = document.getElementById("span" + Node);
									break;
							}
					return (oTable && oTable.style.display == "block");
				}
				
				function toggleNodeVisibility(Node){
					if (nodeIsVisible(Node)){
						hideNode(Node);
					}else{
						showNode(Node);
					}
				}
			</script>
					</head>
		<body>
			<div class="page-body">			
<h2 class="class-name"><img src="../media/images/Class_logo.png"
														alt=" Class"
														title=" Class"
														style="vertical-align: middle"> DomSqlQuery</h2>

<a name="sec-description"></a>
<div class="info-box">
	<div class="info-box-title">Description</div>
	<div class="nav-bar">
					<span class="disabled">Description</span> |
							<a href="#sec-descendents">Descendents</a>
			|											<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
						|											<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
						
											<a href="#sec-const-summary">Constants</a> (<a href="#sec-consts">details</a>)
						
			</div>
	<div class="info-box-body">
        		<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Query object for building SQL queries.</p>
<p class="description"><p>Sample:  <div class="src-code"><ol><li><div class="src-line">&nbsp;<span class="src-var">$result&nbsp;</span>=&nbsp;<span class="src-id"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span><span class="src-sym">::</span><a href="../DomSql/DomSqlQuery.html#methodc">c</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">-&gt;</span><a href="../DomSql/DomSqlQuery.html#methodselect">select</a><span class="src-sym">(</span><span class="src-str">'t.id,t.name'</span><span class="src-sym">)</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">-&gt;</span><a href="../DomSql/DomSqlQuery.html#methodfrom">from</a><span class="src-sym">(</span><span class="src-str">'myTable'</span><span class="src-sym">)</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">-&gt;</span><a href="../DomSql/DomSqlQuery.html#methodwhere">where</a><span class="src-sym">(</span><span class="src-str">'t.id&nbsp;&gt;&nbsp;20'</span><span class="src-sym">)</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">-&gt;</span><a href="../DomSql/DomSqlQuery.html#methodlimit">limit</a><span class="src-sym">(</span><span class="src-num">4</span><span class="src-sym">)</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">-&gt;</span><a href="../DomSql/DomSqlQuery.html#methodcommit">commit</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line">&nbsp;<span class="src-key">foreach</span><span class="src-sym">(&nbsp;</span><span class="src-var">$result&nbsp;</span><span class="src-key">as&nbsp;</span><span class="src-var">$row&nbsp;</span><span class="src-sym">)&nbsp;</span><span class="src-sym">{</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-comm">//...</span></div></li>
<li><div class="src-line">&nbsp;<span class="src-sym">}</span></div></li>
</ol></div></p></p>
		<p class="notes">
			Located in <a class="field" href="_libs---DomSql---Query---DomSqlQuery.class.php.html">/libs/DomSql/Query/DomSqlQuery.class.php</a> (line <span class="field"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a40">40</a></span>)
		</p>
		
				
		<pre></pre>
	
			</div>
</div>

	<a name="sec-descendents"></a>
	<div class="info-box">
		<div class="info-box-title">Direct descendents</div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
			<span class="disabled">Descendents</span>
			|												<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
								|															<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
							
															<a href="#sec-const-summary">Constants</a> (<a href="#sec-consts">details</a>)
							
					</div>
		<div class="info-box-body">
			<table cellpadding="2" cellspacing="0" class="class-table">
				<tr>
					<th class="class-table-header">Class</th>
					<th class="class-table-header">Description</th>
				</tr>
								<tr>
					<td style="padding-right: 2em; white-space: nowrap">
						<img src="../media/images/Class.png"
								 alt=" class"
								 title=" class"
								 style="vertical-align: center"/>
						<a href="../DomAr/Query/DomArDataQuery.html">DomArDataQuery</a>
					</td>
					<td>
											Basic DomSql Query. Uses DomArDataIterator.
										</td>
				</tr>
								<tr>
					<td style="padding-right: 2em; white-space: nowrap">
						<img src="../media/images/Class.png"
								 alt=" class"
								 title=" class"
								 style="vertical-align: center"/>
						<a href="../DomAr/Query/DomArQuery.html">DomArQuery</a>
					</td>
					<td>
											Query that returns objects not data. Uses DomArIterator.
										</td>
				</tr>
							</table>
		</div>
	</div>

	<a name="sec-const-summary"></a>
	<div class="info-box">
		<div class="info-box-title">Class Constant Summary</span></div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
							<a href="#sec-descendents">Descendants</a> |
						<span class="disabled">Constants</span> (<a href="#sec-consts">details</a>)
												<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
				 
				|
										| 
									<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
							
					</div>
		<div class="info-box-body">
			<div class="const-summary">
								<div class="const-title">
					<img src="../media/images/Constant.png" alt=" " />
					<a href="#DEFAULT_WHERE_GROUP" title="details" class="const-name">DEFAULT_WHERE_GROUP</a> = 					<span class="var-type"> 0</span>

				</div>
							</div>
		</div>
	</div>

	<a name="sec-var-summary"></a>
	<div class="info-box">
		<div class="info-box-title">Variable Summary</span></div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
							<a href="#sec-descendents">Descendants</a> |
						<span class="disabled">Vars</span> (<a href="#sec-vars">details</a>)
							| 
									<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
							
															<a href="#sec-const-summary">Constants</a> (<a href="#sec-consts">details</a>)
							
					</div>
		<div class="info-box-body">
			<div class="var-summary">
																																																																																																																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">String</span>
					<a href="#$alias" title="details" class="var-name">$alias</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">Bool</span>
					<a href="#$distinct" title="details" class="var-name">$distinct</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">Array</span>
					<a href="#$fields" title="details" class="var-name">$fields</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">mixed</span>
					<a href="#$from" title="details" class="var-name">$from</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">String</span>
					<a href="#$indexColumnName" title="details" class="var-name">$indexColumnName</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">Array</span>
					<a href="#$joins" title="details" class="var-name">$joins</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">String</span>
					<a href="#$limit" title="details" class="var-name">$limit</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">String</span>
					<a href="#$orderBy" title="details" class="var-name">$orderBy</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">Bool</span>
					<a href="#$sqlCalcFoundRows" title="details" class="var-name">$sqlCalcFoundRows</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">String</span>
					<a href="#$valueColumnName" title="details" class="var-name">$valueColumnName</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">Array</span>
					<a href="#$where" title="details" class="var-name">$where</a>
				</div>
																<div class="var-title">
					<img src="../media/images/Variable.png" alt=" " />
					<span class="var-type">Array</span>
					<a href="#$whereGroups" title="details" class="var-name">$whereGroups</a>
				</div>
											</div>
		</div>
	</div>

	<a name="sec-method-summary"></a>
	<div class="info-box">
		<div class="info-box-title">Method Summary</span></div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
							<a href="#sec-descendents">Descendants</a> |
															<a href="#sec-const-summary">Constants</a> (<a href="#sec-consts">details</a>)
							
															<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
				 
				|
						<span class="disabled">Methods</span> (<a href="#sec-methods">details</a>)
		</div>
		<div class="info-box-body">			
			<div class="method-summary">
																			
				<div class="method-definition">
					<img src="../media/images/StaticMethod.png" alt=" "/>
					static 						<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#c" title="details" class="method-name">c</a>
										()
									</div>
																																																																																																																																																																																																																																																																																			
				<div class="method-definition">
					<img src="../media/images/Constructor.png" alt=" "/>
											<span class="method-result">DomSqlQuery</span>
										<a href="#__construct" title="details" class="method-name">__construct</a>
										()
									</div>
																							
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result">void</span>
										<a href="#commit" title="details" class="method-name">commit</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#countFoundRows" title="details" class="method-name">countFoundRows</a>
											([<span class="var-type"></span>&nbsp;<span class="var-name">$sqlCalcFoundRows</span> = <span class="var-default">false</span>])
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#distinct" title="details" class="method-name">distinct</a>
											([<span class="var-type"></span>&nbsp;<span class="var-name">$value</span> = <span class="var-default">true</span>])
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result">Mixed</span>
										<a href="#execute" title="details" class="method-name">execute</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#flush" title="details" class="method-name">flush</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#flushColumns" title="details" class="method-name">flushColumns</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#flushFields" title="details" class="method-name">flushFields</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#flushFrom" title="details" class="method-name">flushFrom</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#flushJoins" title="details" class="method-name">flushJoins</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#flushLimit" title="details" class="method-name">flushLimit</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#flushOrderBy" title="details" class="method-name">flushOrderBy</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#flushWhere" title="details" class="method-name">flushWhere</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#from" title="details" class="method-name">from</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$tableName</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$as</span> = <span class="var-default">'t'</span>])
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQueryIterator.html">DomSqlQueryIterator</a></span>
										<a href="#getIterator" title="details" class="method-name">getIterator</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#groupBy" title="details" class="method-name">groupBy</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$groupBy</span>)
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#having" title="details" class="method-name">having</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$having</span>)
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#join" title="details" class="method-name">join</a>
											(<span class="var-type">String</span>&nbsp;<span class="var-name">$tableName</span>, <span class="var-type">String</span>&nbsp;<span class="var-name">$as</span>, <span class="var-type">String</span>&nbsp;<span class="var-name">$criteria</span>, [<span class="var-type">Bool</span>&nbsp;<span class="var-name">$shift</span> = <span class="var-default">false</span>], [<span class="var-type">String</span>&nbsp;<span class="var-name">$type</span> = <span class="var-default">'JOIN'</span>])
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#leftJoin" title="details" class="method-name">leftJoin</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$tableName</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$as</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$criteria</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$shift</span> = <span class="var-default">false</span>])
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#limit" title="details" class="method-name">limit</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$limit</span>)
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#matchAgainst" title="details" class="method-name">matchAgainst</a>
											(<span class="var-type">String</span>&nbsp;<span class="var-name">$columns</span>, <span class="var-type">String</span>&nbsp;<span class="var-name">$against</span>, [<span class="var-type">String</span>&nbsp;<span class="var-name">$as</span> = <span class="var-default">NULL</span>], [<span class="var-type">String</span>&nbsp;<span class="var-name">$mode</span> = <span class="var-default">''</span>])
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#orderBy" title="details" class="method-name">orderBy</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$orderBy</span>)
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#rightJoin" title="details" class="method-name">rightJoin</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$tableName</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$as</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$criteria</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$shift</span> = <span class="var-default">false</span>])
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#select" title="details" class="method-name">select</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#setAlias" title="details" class="method-name">setAlias</a>
											(<span class="var-type">String</span>&nbsp;<span class="var-name">$alias</span>)
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#setIndexColumnName" title="details" class="method-name">setIndexColumnName</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$indexColumnName</span>)
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#setValueColumnName" title="details" class="method-name">setValueColumnName</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$valueColumnName</span>)
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result">String</span>
										<a href="#toCountString" title="details" class="method-name">toCountString</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result">String</span>
										<a href="#toString" title="details" class="method-name">toString</a>
										()
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#where" title="details" class="method-name">where</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$where</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$group</span> = <span class="var-default">self::DEFAULT_WHERE_GROUP</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$groupLogic</span> = <span class="var-default">'AND'</span>])
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
										<a href="#whereOr" title="details" class="method-name">whereOr</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$where</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$group</span> = <span class="var-default">self::DEFAULT_WHERE_GROUP</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$groupLogic</span> = <span class="var-default">'AND'</span>])
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result">Mixed</span>
										<a href="#__get" title="details" class="method-name">__get</a>
											(<span class="var-type">String</span>&nbsp;<span class="var-name">$var</span>)
									</div>
															
				<div class="method-definition">
					<img src="../media/images/Method.png" alt=" "/>
											<span class="method-result">String</span>
										<a href="#__toString" title="details" class="method-name">__toString</a>
										()
									</div>
											</div>
		</div>
	</div>		

	<a name="sec-vars"></a>
	<div class="info-box">
		<div class="info-box-title">Variables</div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
							<a href="#sec-descendents">Descendents</a> |
										<a href="#sec-var-summary">Vars</a> (<span class="disabled">details</span>)
						
			
												<a href="#sec-const-summary">Constants</a> (<a href="#sec-consts">details</a>)
							
										| 
									<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
							
					</div>
		<div class="info-box-body">
			
<a name="var$alias" id="$alias"><!-- --></A>
<div class="evenrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">String</span>
			<span class="var-name">$alias</span>
			 = <span class="var-default"> DomSql::DEFAULT_ALIAS</span>			(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a48">48</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Connection alias</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$distinct" id="$distinct"><!-- --></A>
<div class="oddrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">Bool</span>
			<span class="var-name">$distinct</span>
			 = <span class="var-default"> false</span>			(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a66">66</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Use DISTINCT on select query</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$fields" id="$fields"><!-- --></A>
<div class="evenrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">Array</span>
			<span class="var-name">$fields</span>
			 = <span class="var-default">array()</span>			(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a54">54</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Fields that are used by this query</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$from" id="$from"><!-- --></A>
<div class="oddrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">mixed</span>
			<span class="var-name">$from</span>
			 = <span class="var-default">array()</span>			(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a71">71</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$indexColumnName" id="$indexColumnName"><!-- --></A>
<div class="evenrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">String</span>
			<span class="var-name">$indexColumnName</span>
			 = <span class="var-default"> NULL</span>			(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a107">107</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Result set index/key column name.</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$joins" id="$joins"><!-- --></A>
<div class="oddrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">Array</span>
			<span class="var-name">$joins</span>
			 = <span class="var-default">array()</span>			(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a60">60</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Joins that are made</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$limit" id="$limit"><!-- --></A>
<div class="evenrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">String</span>
			<span class="var-name">$limit</span>
						(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a101">101</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Limit part</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$orderBy" id="$orderBy"><!-- --></A>
<div class="oddrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">String</span>
			<span class="var-name">$orderBy</span>
						(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a95">95</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Order by part</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$sqlCalcFoundRows" id="$sqlCalcFoundRows"><!-- --></A>
<div class="evenrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">Bool</span>
			<span class="var-name">$sqlCalcFoundRows</span>
						(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a89">89</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Whether to use SQL_CALC_FOUND_ROWS(true) or send count(*)(false) query to count all possible matches.</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$valueColumnName" id="$valueColumnName"><!-- --></A>
<div class="oddrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">String</span>
			<span class="var-name">$valueColumnName</span>
			 = <span class="var-default"> NULL</span>			(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a113">113</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Result set value column name</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$where" id="$where"><!-- --></A>
<div class="evenrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">Array</span>
			<span class="var-name">$where</span>
			 = <span class="var-default">array()</span>			(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a77">77</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Queries where clauses</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
<a name="var$whereGroups" id="$whereGroups"><!-- --></A>
<div class="oddrow">

	<div class="var-header">
		<img src="../media/images/Variable.png" />
		<span class="var-title">
			<span class="var-type">Array</span>
			<span class="var-name">$whereGroups</span>
			 = <span class="var-default">array()</span>			(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a83">83</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Where groups</p>
	<ul class="tags">
				<li><span class="field">access:</span> protected</li>
			</ul>
	
	
		
		

</div>
						
		</div>
	</div>
	
	<a name="sec-methods"></a>
	<div class="info-box">
		<div class="info-box-title">Methods</div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
							<a href="#sec-descendents">Descendents</a> |
															<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
																			<a href="#sec-const-summary">Constants</a> (<a href="#sec-consts">details</a>)
							
										<a href="#sec-method-summary">Methods</a> (<span class="disabled">details</span>)
						
		</div>
		<div class="info-box-body">
			<A NAME='method_detail'></A>
<a name="methodc" id="c"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/StaticMethod.png" />
		<span class="method-title">static c</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a121">121</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		static <span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			c
		</span>
				()
			</div>
	
		
			
			<hr class="separator" />
		<div class="notes">Redefined in descendants as:</div>
		<ul class="redefinitions">
					<li>
				<a href="../DomAr/Query/DomArDataQuery.html#methodc">DomArDataQuery::c()</a>
							</li>
					<li>
				<a href="../DomAr/Query/DomArQuery.html#methodc">DomArQuery::c()</a>
							</li>
				</ul>
	</div>
<a name="method__construct" id="__construct"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Constructor.png" />
		<span class="method-title">Constructor __construct</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a115">115</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">DomSqlQuery</span>
		<span class="method-name">
			__construct
		</span>
				()
			</div>
	
		
			
			<hr class="separator" />
		<div class="notes">Redefined in descendants as:</div>
		<ul class="redefinitions">
					<li>
				<a href="../DomAr/Query/DomArQuery.html#method__construct">DomArQuery::__construct()</a>
							</li>
				</ul>
	</div>
<a name="methodcommit" id="commit"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">commit</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a398">398</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Alias for execute.</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			commit
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodcountFoundRows" id="countFoundRows"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">countFoundRows</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a273">273</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			countFoundRows
		</span>
					([<span class="var-type"></span>&nbsp;<span class="var-name">$sqlCalcFoundRows</span> = <span class="var-default">false</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$sqlCalcFoundRows</span>			</li>
				</ul>
		
			
	</div>
<a name="methoddistinct" id="distinct"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">distinct</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a173">173</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			distinct
		</span>
					([<span class="var-type"></span>&nbsp;<span class="var-name">$value</span> = <span class="var-default">true</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$value</span>			</li>
				</ul>
		
			
	</div>
<a name="methodexecute" id="execute"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">execute</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a385">385</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">DomSqlQueryIterator is returned when limit is not 1.</p>
<p class="description"><p>Row is returned when limit === 1</p></p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">Mixed</span>
		<span class="method-name">
			execute
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodflush" id="flush"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">flush</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a454">454</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			flush
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodflushColumns" id="flushColumns"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">flushColumns</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a413">413</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			flushColumns
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodflushFields" id="flushFields"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">flushFields</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a406">406</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">deprecated:</span> </li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			flushFields
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodflushFrom" id="flushFrom"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">flushFrom</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a426">426</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			flushFrom
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodflushJoins" id="flushJoins"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">flushJoins</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a419">419</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			flushJoins
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodflushLimit" id="flushLimit"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">flushLimit</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a447">447</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			flushLimit
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodflushOrderBy" id="flushOrderBy"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">flushOrderBy</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a440">440</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			flushOrderBy
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodflushWhere" id="flushWhere"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">flushWhere</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a433">433</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			flushWhere
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodfrom" id="from"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">from</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a180">180</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			from
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$tableName</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$as</span> = <span class="var-default">'t'</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$tableName</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$as</span>			</li>
				</ul>
		
			
	</div>
<a name="methodgetIterator" id="getIterator"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">getIterator</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a377">377</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQueryIterator.html">DomSqlQueryIterator</a></span>
		<span class="method-name">
			getIterator
		</span>
				()
			</div>
	
		
			
			<hr class="separator" />
		<div class="notes">Redefined in descendants as:</div>
		<ul class="redefinitions">
					<li>
				<a href="../DomAr/Query/DomArDataQuery.html#methodgetIterator">DomArDataQuery::getIterator()</a>
							</li>
					<li>
				<a href="../DomAr/Query/DomArQuery.html#methodgetIterator">DomArQuery::getIterator()</a>
								: Get Iterator object for this query.
							</li>
				</ul>
	</div>
<a name="methodgroupBy" id="groupBy"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">groupBy</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a294">294</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			groupBy
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$groupBy</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$groupBy</span>			</li>
				</ul>
		
			
	</div>
<a name="methodhaving" id="having"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">having</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a301">301</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			having
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$having</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$having</span>			</li>
				</ul>
		
			
	</div>
<a name="methodjoin" id="join"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">join</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a245">245</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			join
		</span>
					(<span class="var-type">String</span>&nbsp;<span class="var-name">$tableName</span>, <span class="var-type">String</span>&nbsp;<span class="var-name">$as</span>, <span class="var-type">String</span>&nbsp;<span class="var-name">$criteria</span>, [<span class="var-type">Bool</span>&nbsp;<span class="var-name">$shift</span> = <span class="var-default">false</span>], [<span class="var-type">String</span>&nbsp;<span class="var-name">$type</span> = <span class="var-default">'JOIN'</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">String</span>
				<span class="var-name">$tableName</span>			</li>
					<li>
				<span class="var-type">String</span>
				<span class="var-name">$as</span>			</li>
					<li>
				<span class="var-type">String</span>
				<span class="var-name">$criteria</span><span class="var-description">: ON clause</span>			</li>
					<li>
				<span class="var-type">Bool</span>
				<span class="var-name">$shift</span><span class="var-description">: Add at the beginning of joins</span>			</li>
					<li>
				<span class="var-type">String</span>
				<span class="var-name">$type</span><span class="var-description">: [JOIN|LEFT JOIN|RIGHT_JOIN]</span>			</li>
				</ul>
		
			
	</div>
<a name="methodleftJoin" id="leftJoin"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">leftJoin</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a259">259</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Alias for join</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			leftJoin
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$tableName</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$as</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$criteria</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$shift</span> = <span class="var-default">false</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$tableName</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$as</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$criteria</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$shift</span>			</li>
				</ul>
		
			
	</div>
<a name="methodlimit" id="limit"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">limit</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a287">287</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			limit
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$limit</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$limit</span>			</li>
				</ul>
		
			
	</div>
<a name="methodmatchAgainst" id="matchAgainst"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">matchAgainst</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a230">230</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Performs fulltext search. See Mysql manual about FULLTEXT searches.</p>
<p class="description"><p>If &quot;as&quot; is added, MATCH .. AGAINST  part is also put into select part.</p></p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			matchAgainst
		</span>
					(<span class="var-type">String</span>&nbsp;<span class="var-name">$columns</span>, <span class="var-type">String</span>&nbsp;<span class="var-name">$against</span>, [<span class="var-type">String</span>&nbsp;<span class="var-name">$as</span> = <span class="var-default">NULL</span>], [<span class="var-type">String</span>&nbsp;<span class="var-name">$mode</span> = <span class="var-default">''</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">String</span>
				<span class="var-name">$columns</span>			</li>
					<li>
				<span class="var-type">String</span>
				<span class="var-name">$against</span>			</li>
					<li>
				<span class="var-type">String</span>
				<span class="var-name">$as</span>			</li>
					<li>
				<span class="var-type">String</span>
				<span class="var-name">$mode</span>			</li>
				</ul>
		
			
	</div>
<a name="methodorderBy" id="orderBy"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">orderBy</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a280">280</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			orderBy
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$orderBy</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$orderBy</span>			</li>
				</ul>
		
			
	</div>
<a name="methodrightJoin" id="rightJoin"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">rightJoin</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a266">266</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			rightJoin
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$tableName</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$as</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$criteria</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$shift</span> = <span class="var-default">false</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$tableName</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$as</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$criteria</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$shift</span>			</li>
				</ul>
		
			
	</div>
<a name="methodselect" id="select"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">select</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a159">159</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Arguments can be given as seperate params.</p>
<p class="description"><p><div class="src-code"><ol><li><div class="src-line">&nbsp;<span class="src-var">$query</span><span class="src-sym">-&gt;</span><a href="../DomSql/DomSqlQuery.html#methodselect">select</a><span class="src-sym">(</span><span class="src-str">'t.id,&nbsp;t.name&nbsp;as&nbsp;itemName'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line">&nbsp;<span class="src-var">$query</span><span class="src-sym">-&gt;</span><a href="../DomSql/DomSqlQuery.html#methodselect">select</a><span class="src-sym">(</span><span class="src-str">'t.id'</span><span class="src-sym">,</span><span class="src-str">'t.name&nbsp;as&nbsp;itemName'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line">&nbsp;<span class="src-var">$query</span><span class="src-sym">-&gt;</span><a href="../DomSql/DomSqlQuery.html#methodselect">select</a><span class="src-sym">(</span><span class="src-str">'t.id'</span><span class="src-sym">,</span><span class="src-key">array</span><span class="src-sym">(</span><span class="src-str">'t.name'</span><span class="src-sym">,</span><span class="src-str">'itemname'</span><span class="src-sym">))</span></div></li>
</ol></div></p></p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			select
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodsetAlias" id="setAlias"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">setAlias</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a128">128</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			setAlias
		</span>
					(<span class="var-type">String</span>&nbsp;<span class="var-name">$alias</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">String</span>
				<span class="var-name">$alias</span>			</li>
				</ul>
		
			
	</div>
<a name="methodsetIndexColumnName" id="setIndexColumnName"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">setIndexColumnName</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a137">137</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">This column value is returned as key. (Key's don't have to be unique, you will still get all results!)</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			setIndexColumnName
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$indexColumnName</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$indexColumnName</span>			</li>
				</ul>
		
			
	</div>
<a name="methodsetValueColumnName" id="setValueColumnName"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">setValueColumnName</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a146">146</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">This column value is returned as value.</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			setValueColumnName
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$valueColumnName</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$valueColumnName</span>			</li>
				</ul>
		
			
	</div>
<a name="methodtoCountString" id="toCountString"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">toCountString</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a308">308</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">String</span>
		<span class="method-name">
			toCountString
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodtoString" id="toString"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">toString</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a339">339</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">String</span>
		<span class="method-name">
			toString
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodwhere" id="where"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">where</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a199">199</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="description"><p>$q-&gt;where('t.id = 10')  $q-&gt;where('t.id = 10 OR t.id = 12'); // 10 or 12  $q-&gt;where('t.id  = 10')-&gt;where('t.id = 12'); // 10 and 12  $q-&gt;where('t.id  = 10')-&gt;whereOr('t.id = 12'); // 10 or 12  $q-&gt;where('t.id = 10', 'g')-&gt;whereOr('t.id = 12', 'g')-&gt;where('t.id = 13'); // (10 OR 12) AND 13  $q-&gt;where('t.id = 10', 'g')-&gt;whereOr('t.id = 12', 'g')-&gt;where('t.id = 13')-&gt;where('t.id = 14'); // (10 OR 12) AND (13 AND 14)  $q-&gt;whereOr('t.id = 10', 'g')-&gt;whereOr('t.id = 12', 'g')-&gt;whereOr('t.id = 13')-&gt;whereOr('t.id = 14'); // (10 OR 12) AND (13 OR 14)  &lt;/code&gt;</p></p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			where
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$where</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$group</span> = <span class="var-default">self::DEFAULT_WHERE_GROUP</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$groupLogic</span> = <span class="var-default">'AND'</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$where</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$group</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$groupLogic</span>			</li>
				</ul>
		
			
	</div>
<a name="methodwhereOr" id="whereOr"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">whereOr</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a211">211</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../DomSql/DomSqlQuery.html">DomSqlQuery</a></span>
		<span class="method-name">
			whereOr
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$where</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$group</span> = <span class="var-default">self::DEFAULT_WHERE_GROUP</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$groupLogic</span> = <span class="var-default">'AND'</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$where</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$group</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$groupLogic</span>			</li>
				</ul>
		
			
	</div>
<a name="method__get" id="__get"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">__get</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a466">466</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">Mixed</span>
		<span class="method-name">
			__get
		</span>
					(<span class="var-type">String</span>&nbsp;<span class="var-name">$var</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">String</span>
				<span class="var-name">$var</span>			</li>
				</ul>
		
			
	</div>
<a name="method__toString" id="__toString"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<img src="../media/images/Method.png" />
		<span class="method-title">__toString</span> (line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a472">472</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">String</span>
		<span class="method-name">
			__toString
		</span>
				()
			</div>
	
		
			
	</div>
						
		</div>
	</div>

	<a name="sec-consts"></a>
	<div class="info-box">
		<div class="info-box-title">Class Constants</div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
							<a href="#sec-descendents">Descendants</a> |
										<a href="#sec-var-summary">Constants</a> (<span class="disabled">details</span>)
						
			
												<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
														| 
									<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
							
					</div>
		<div class="info-box-body">
			<a name="constDEFAULT_WHERE_GROUP" id="DEFAULT_WHERE_GROUP"><!-- --></A>
<div class="evenrow">

	<div class="const-header">
		<img src="../media/images/Variable.png" />
		<span class="const-title">
			<span class="const-name">DEFAULT_WHERE_GROUP</span>
			 = <span class="const-default"> 0</span>
			(line <span class="line-number"><a href="../__filesource/fsource_DomSql__libsDomSqlQueryDomSqlQuery.class.php.html#a42">42</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
	
	
</div>
						
		</div>
	</div>
	
	<p class="notes" id="credit">
		Documentation generated on Fri, 24 Sep 2010 21:14:18 +0000 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.4.1</a>
	</p>
	</div></body>
</html>